package com.sk.skplanet.commute.vo;

import android.net.Uri;
import android.provider.BaseColumns;

public final class BusTblInfo {
	// 추가됨
		public static final String AUTHORITY = "com.sk.skplanet.commute.localdata.Point";

		public static final class points implements BaseColumns{
			// 추가됨
			public static final Uri CONTENT_URI = Uri.parse("content://"+AUTHORITY+"/points");
			public static final String NAME = "name";
			public static final String _TABLENAME = "points";
			public static final String _CREATE = 
				"create table "+_TABLENAME+"("+_ID+" integer primary key autoincrement, "
				+NAME+" text not null);";
		}
		
		public static final class stopInfos implements BaseColumns {
			public static final Uri CONTENT_URI = Uri.parse("content://"+AUTHORITY+"/stopinfos");
			public static final String STOPID = "stopId";
			public static final String BUSID = "busId";
			public static final String STOPNAME = "stopName";
			public static final String BUSNAME = "busName";
			public static final String BUSTYPE = "busType";
			public static final String POINTID = "P_id";
			public static final String _TABLENAME = "stopinfos";
			
			public static final String _CREATE = 
				"create table "+_TABLENAME+"("+_ID+" integer primary key autoincrement, "
				+STOPID+" text not null, "
				+BUSID+" text not null, "
				+STOPNAME+" text not null, "
				+BUSNAME+" text not null, "
				+BUSTYPE+" text not null, "
				+POINTID+" integer not null, "
				+"FOREIGN KEY("+POINTID+") REFERENCES points("+_ID+"));";
				//+POINTID+" int FOREIGN KEY REFERENCES points("+_ID+"));";
		}
}
